INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%CD Album%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid='12' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='12' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%CD Album%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid
Great box sets by the like of Dolly Parton and general artists. If you're after Hank Willoams and Johnny Cash LPs or modern chicks like Lucinda Williams, this is the section to look in. ::
Country
:: Music
:: Elvis Shakespeare
Opening Hours
Mon-Sat: 10.00-18.00
Sun: Closed for the winter (open again in May)
Great box sets by the like of Dolly Parton and general artists. If you're after Hank Willoams and Johnny Cash LPs or modern chicks like Lucinda Williams, this is the section to look in.
Country
There are no available products under this category.
Great box sets by the like of Dolly Parton and general artists. If you're after Hank Willoams and Johnny Cash LPs or modern chicks like Lucinda Williams, this is the section to look in. ::
Country
:: Music
:: Elvis Shakespeare